Model Table MARKETING CAMPAIGN ACTION FACT

This model dimension represents actions created in marketing campaigns and is based on the IFS Cloud fact FACT_BUSINESS_ACTIVITY. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
Campaign Activity Sub Type	Activity Sub Types are used to specify the nature of an activity.
Campaign Activity Type	The Activity Type shows whether the action is a Meeting, Task, Call, Chat or E-Mail.
Campaign Activity Type ID	The Activity Type shows whether the action is a Meeting, Task, Call, Chat or E-Mail.
Marketing Campaign Action Cost	The cost involved in the marketing campaign action.
Marketing Campaign Action Description	Marketing campaign action description.
Marketing Campaign Action Header Item
Marketing Campaign Action Number	The ID of the marketing campaign action.
Marketing Campaign Action Response Category	The response category assigned to the marketing campaign action.
Marketing Campaign Action Status	The status of the marketing campaign action.

USED BY MODEL(S)

Model Name

Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
MARKETING CAMPAIGN ACTION FACT	FACT_MARKETING_CAMP_ACTION_TM	FACT_MARKETING_CAMP_ACTION_BI	FACT_MARKETING_CAMP_ACTION	Data Mart